DBS TxLog Management Utility

The DBS TxLog Management utility (DbsTxLogManagement.exe) is a command-line utility that is used to change the value for the DBS_TRANSACTION_LOG_SIZE keyword in the service configuration file. The DBS_TRANSACTION_LOG_SIZE keyword specifies the size (in megabytes) of each log file in the txlogs directory, the directory where the service transaction log files are stored.

DbsTxLogManagement will perform the following steps:

  1. Check if the .dat.edb and .inx.edb files are clean.
  2. If clean, the utility will change the DBS_TRANSACTION_LOG_SIZE to the new value.
  3. After the value is changed, the utility will delete the txlogs directory.

Step 3 is potentially dangerous and the reason this utility is provided. If the .dat.edb and .inx.edb files are not clean and the txlogs directory doesn’t have good data, the databases will have to be restored from the previous backup.

Since incremental backups require that the transaction log file size be consistent, changing the value of the DBS_TRANSACTION_LOG_SIZE service configuration keyword without deleting the txlogs directory will cause the service to fail to start, reporting the error JET_errLogFileSizeMismatchDatabasesConsistent, meaning that the database is now brought up-to-date with its last committed transaction (if there was a bad shutdown).

This utility requires that the DBS-based service be stopped.

Warning: Use this utility only in consultation with CygNet Support. A large log file size is good for databases that change frequently as the transaction logs will not rollover as quickly, but this can increase startup time if the majority of the services are configured with large file sizes. The default values for the DBS_TRANSACTION_LOG_SIZE keyword should be adequate, but the value is configurable if the default does not meet the specific environment. See the Service Configuration Keyword for each service (ACS, APPS, AUD, BSS, DBS, DDS, ELS, ELSALM, FAC, GNS, GRP, MSS, PNT, and TRS) for the keyword default values, which differ for each service.

Syntax

DbsTxLogManagement NewSize ConfigFileName

Parameters

Parameter Definition

NewSize

The size (in megabytes) of each log file in the txlogs directory.

ConfigFileName

The name of the service configuration file. If no ConfigFileName is specified, the utility uses the configuration file in the startup directory.

Example

DBSTxLogManagement 10 C:\CygNet\Services\AUD\Aud.cfg